Dataset statistics
| Number of variables | 8 |
|---|---|
| Number of observations | 1304 |
| Missing cells | 309 |
| Missing cells (%) | 3.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 81.6 KiB |
| Average record size in memory | 64.1 B |
Variable types
| NUM | 7 |
|---|---|
| CAT | 1 |
other_rooms has 309 (23.7%) missing values | Missing |
df_index has unique values | Unique |
bathrooms has 15 (1.2%) zeros | Zeros |
other_rooms has 977 (74.9%) zeros | Zeros |
Reproduction
| Analysis started | 2021-06-05 21:03:49.897079 |
|---|---|
| Analysis finished | 2021-06-05 21:03:59.866774 |
| Duration | 9.97 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 1304 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15850.53758 |
|---|---|
| Minimum | 286 |
| Maximum | 21727 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 10.2 KiB |
Quantile statistics
| Minimum | 286 |
|---|---|
| 5-th percentile | 9117.8 |
| Q1 | 13410.5 |
| median | 16353.5 |
| Q3 | 18949.25 |
| 95-th percentile | 20292.35 |
| Maximum | 21727 |
| Range | 21441 |
| Interquartile range (IQR) | 5538.75 |
Descriptive statistics
| Standard deviation | 3827.061894 |
|---|---|
| Coefficient of variation (CV) | 0.24144682 |
| Kurtosis | 2.443174668 |
| Mean | 15850.53758 |
| Median Absolute Deviation (MAD) | 2782 |
| Skewness | -1.244995471 |
| Sum | 20669101 |
| Variance | 14646402.74 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 12285 | 1 | 0.1% | |
| 17133 | 1 | 0.1% | |
| 19147 | 1 | 0.1% | |
| 21199 | 1 | 0.1% | |
| 21200 | 1 | 0.1% | |
| 13010 | 1 | 0.1% | |
| 13013 | 1 | 0.1% | |
| 19160 | 1 | 0.1% | |
| 21209 | 1 | 0.1% | |
| 21211 | 1 | 0.1% | |
| Other values (1294) | 1294 | 99.2% |
| Value | Count | Frequency (%) | |
| 286 | 1 | 0.1% | |
| 287 | 1 | 0.1% | |
| 299 | 1 | 0.1% | |
| 419 | 1 | 0.1% | |
| 577 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 21727 | 1 | 0.1% | |
| 21617 | 1 | 0.1% | |
| 21608 | 1 | 0.1% | |
| 21565 | 1 | 0.1% | |
| 21506 | 1 | 0.1% |
property_status
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.2 KiB |
| Used | |
|---|---|
| New | |
| Not Applicable | |
| Under Construction | 1 |
| Value | Count | Frequency (%) | |
| Used | 686 | 52.6% | |
| New | 467 | 35.8% | |
| Not Applicable | 150 | 11.5% | |
| Under Construction | 1 | 0.1% |
Frequencies of value counts
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.1% |
Histogram of lengths of the category
Length
| Max length | 18 |
|---|---|
| Median length | 4 |
| Mean length | 4.80291411 |
| Min length | 3 |
price
Real number (ℝ≥0)
| Distinct | 356 |
|---|---|
| Distinct (%) | 27.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66895.77147 |
|---|---|
| Minimum | 280 |
| Maximum | 340000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 10.2 KiB |
Quantile statistics
| Minimum | 280 |
|---|---|
| 5-th percentile | 39075 |
| Q1 | 52750 |
| median | 65000 |
| Q3 | 77000 |
| 95-th percentile | 101683.2 |
| Maximum | 340000 |
| Range | 339720 |
| Interquartile range (IQR) | 24250 |
Descriptive statistics
| Standard deviation | 23381.71764 |
|---|---|
| Coefficient of variation (CV) | 0.3495245982 |
| Kurtosis | 26.66177476 |
| Mean | 66895.77147 |
| Median Absolute Deviation (MAD) | 12000 |
| Skewness | 3.273071013 |
| Sum | 87232086 |
| Variance | 546704719.9 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 65000 | 48 | 3.7% | |
| 70000 | 42 | 3.2% | |
| 75000 | 42 | 3.2% | |
| 55000 | 30 | 2.3% | |
| 60000 | 28 | 2.1% | |
| 80000 | 27 | 2.1% | |
| 58000 | 26 | 2.0% | |
| 43000 | 26 | 2.0% | |
| 45000 | 26 | 2.0% | |
| 62000 | 25 | 1.9% | |
| Other values (346) | 984 | 75.5% |
| Value | Count | Frequency (%) | |
| 280 | 1 | 0.1% | |
| 26000 | 1 | 0.1% | |
| 26500 | 1 | 0.1% | |
| 27000 | 1 | 0.1% | |
| 28000 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 340000 | 1 | 0.1% | |
| 300000 | 1 | 0.1% | |
| 250000 | 1 | 0.1% | |
| 210000 | 1 | 0.1% | |
| 199000 | 1 | 0.1% |
interior_area
Real number (ℝ≥0)
| Distinct | 135 |
|---|---|
| Distinct (%) | 10.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98.48389571 |
|---|---|
| Minimum | 40 |
| Maximum | 427 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 10.2 KiB |
Quantile statistics
| Minimum | 40 |
|---|---|
| 5-th percentile | 63 |
| Q1 | 76 |
| median | 99 |
| Q3 | 112 |
| 95-th percentile | 137 |
| Maximum | 427 |
| Range | 387 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 31.57548499 |
|---|---|
| Coefficient of variation (CV) | 0.3206157186 |
| Kurtosis | 24.61358459 |
| Mean | 98.48389571 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 3.367160887 |
| Sum | 128423 |
| Variance | 997.0112523 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 100 | 43 | 3.3% | |
| 112 | 36 | 2.8% | |
| 108 | 32 | 2.5% | |
| 104 | 31 | 2.4% | |
| 98 | 30 | 2.3% | |
| 105 | 28 | 2.1% | |
| 106 | 28 | 2.1% | |
| 90 | 28 | 2.1% | |
| 70 | 27 | 2.1% | |
| 109 | 27 | 2.1% | |
| Other values (125) | 994 | 76.2% |
| Value | Count | Frequency (%) | |
| 40 | 1 | 0.1% | |
| 44 | 1 | 0.1% | |
| 45 | 2 | 0.2% | |
| 48 | 4 | 0.3% | |
| 50 | 2 | 0.2% |
| Value | Count | Frequency (%) | |
| 427 | 1 | 0.1% | |
| 385 | 1 | 0.1% | |
| 371 | 1 | 0.1% | |
| 342 | 1 | 0.1% | |
| 300 | 1 | 0.1% |
gros_area
Real number (ℝ≥0)
| Distinct | 144 |
|---|---|
| Distinct (%) | 11.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101.5138037 |
|---|---|
| Minimum | 44 |
| Maximum | 427 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 10.2 KiB |
Quantile statistics
| Minimum | 44 |
|---|---|
| 5-th percentile | 64 |
| Q1 | 77 |
| median | 100 |
| Q3 | 112 |
| 95-th percentile | 145 |
| Maximum | 427 |
| Range | 383 |
| Interquartile range (IQR) | 35 |
Descriptive statistics
| Standard deviation | 37.36028721 |
|---|---|
| Coefficient of variation (CV) | 0.3680315962 |
| Kurtosis | 21.70282905 |
| Mean | 101.5138037 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 3.646046779 |
| Sum | 132374 |
| Variance | 1395.79106 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 100 | 39 | 3.0% | |
| 112 | 36 | 2.8% | |
| 108 | 32 | 2.5% | |
| 98 | 31 | 2.4% | |
| 104 | 31 | 2.4% | |
| 105 | 29 | 2.2% | |
| 106 | 29 | 2.2% | |
| 109 | 27 | 2.1% | |
| 103 | 26 | 2.0% | |
| 90 | 26 | 2.0% | |
| Other values (134) | 998 | 76.5% |
| Value | Count | Frequency (%) | |
| 44 | 1 | 0.1% | |
| 45 | 1 | 0.1% | |
| 48 | 3 | 0.2% | |
| 50 | 1 | 0.1% | |
| 51 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 427 | 1 | 0.1% | |
| 393 | 1 | 0.1% | |
| 391 | 1 | 0.1% | |
| 385 | 1 | 0.1% | |
| 371 | 1 | 0.1% |
bedrooms
Real number (ℝ≥0)
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.769171779 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 4 |
| Zeros (%) | 0.3% |
| Memory size | 10.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.5964339574 |
|---|---|
| Coefficient of variation (CV) | 0.337126086 |
| Kurtosis | 0.783139381 |
| Mean | 1.769171779 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.239167673 |
| Sum | 2307 |
| Variance | 0.3557334655 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) | |
| 2 | 806 | 61.8% | |
| 1 | 397 | 30.4% | |
| 3 | 91 | 7.0% | |
| 4 | 5 | 0.4% | |
| 0 | 4 | 0.3% | |
| 5 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 4 | 0.3% | |
| 1 | 397 | 30.4% | |
| 2 | 806 | 61.8% | |
| 3 | 91 | 7.0% | |
| 4 | 5 | 0.4% |
| Value | Count | Frequency (%) | |
| 5 | 1 | 0.1% | |
| 4 | 5 | 0.4% | |
| 3 | 91 | 7.0% | |
| 2 | 806 | 61.8% | |
| 1 | 397 | 30.4% |
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.435582822 |
|---|---|
| Minimum | 0 |
| Maximum | 21 |
| Zeros | 15 |
| Zeros (%) | 1.2% |
| Memory size | 10.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7569524049 |
|---|---|
| Coefficient of variation (CV) | 0.5272788119 |
| Kurtosis | 341.6391126 |
| Mean | 1.435582822 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.33526062 |
| Sum | 1872 |
| Variance | 0.5729769433 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) | |
| 1 | 731 | 56.1% | |
| 2 | 553 | 42.4% | |
| 0 | 15 | 1.2% | |
| 4 | 2 | 0.2% | |
| 3 | 2 | 0.2% | |
| 21 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 15 | 1.2% | |
| 1 | 731 | 56.1% | |
| 2 | 553 | 42.4% | |
| 3 | 2 | 0.2% | |
| 4 | 2 | 0.2% |
| Value | Count | Frequency (%) | |
| 21 | 1 | 0.1% | |
| 4 | 2 | 0.2% | |
| 3 | 2 | 0.2% | |
| 2 | 553 | 42.4% | |
| 1 | 731 | 56.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 309 |
| Missing (%) | 23.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.02713567839 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros | 977 |
| Zeros (%) | 74.9% |
| Memory size | 10.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2293094714 |
|---|---|
| Coefficient of variation (CV) | 8.450478669 |
| Kurtosis | 142.8931281 |
| Mean | 0.02713567839 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.92900813 |
| Sum | 27 |
| Variance | 0.05258283369 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=5)
| Value | Count | Frequency (%) | |
| 0 | 977 | 74.9% | |
| 1 | 12 | 0.9% | |
| 2 | 4 | 0.3% | |
| 3 | 1 | 0.1% | |
| 4 | 1 | 0.1% | |
| (Missing) | 309 | 23.7% |
| Value | Count | Frequency (%) | |
| 0 | 977 | 74.9% | |
| 1 | 12 | 0.9% | |
| 2 | 4 | 0.3% | |
| 3 | 1 | 0.1% | |
| 4 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 4 | 1 | 0.1% | |
| 3 | 1 | 0.1% | |
| 2 | 4 | 0.3% | |
| 1 | 12 | 0.9% | |
| 0 | 977 | 74.9% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | property_status | price | interior_area | gros_area | bedrooms | bathrooms | other_rooms | |
|---|---|---|---|---|---|---|---|---|
| 0 | 20102 | New | 66000.0 | 110.0 | 110.0 | 2 | 2.0 | 0.0 |
| 1 | 19641 | Used | 65000.0 | 119.0 | 119.0 | 2 | 2.0 | 0.0 |
| 2 | 20146 | New | 39000.0 | 69.0 | 69.0 | 1 | 1.0 | 0.0 |
| 3 | 20100 | New | 63000.0 | 103.0 | 103.0 | 2 | 2.0 | 0.0 |
| 4 | 19650 | New | 41000.0 | 75.0 | 75.0 | 1 | 1.0 | 0.0 |
| 5 | 19686 | New | 46000.0 | 70.0 | 70.0 | 1 | 1.0 | 0.0 |
| 6 | 20105 | New | 52000.0 | 98.0 | 98.0 | 2 | 2.0 | 0.0 |
| 7 | 13781 | Used | 55000.0 | 61.0 | 61.0 | 1 | 1.0 | NaN |
| 8 | 11496 | Not Applicable | 100000.0 | 114.0 | 114.0 | 2 | 2.0 | NaN |
| 9 | 17142 | Used | 59000.0 | 75.0 | 120.0 | 1 | 1.0 | 0.0 |
Last rows
| df_index | property_status | price | interior_area | gros_area | bedrooms | bathrooms | other_rooms | |
|---|---|---|---|---|---|---|---|---|
| 1294 | 826 | Used | 49000.0 | 64.0 | 64.0 | 1 | 1.0 | 0.0 |
| 1295 | 19365 | New | 66960.0 | 112.0 | 112.0 | 2 | 2.0 | 0.0 |
| 1296 | 19204 | Used | 50000.0 | 89.0 | 89.0 | 1 | 1.0 | 0.0 |
| 1297 | 19366 | New | 64350.0 | 117.0 | 117.0 | 2 | 2.0 | 0.0 |
| 1298 | 17373 | Used | 66960.0 | 108.0 | 108.0 | 2 | 2.0 | 0.0 |
| 1299 | 11572 | Not Applicable | 72000.0 | 90.0 | 90.0 | 2 | 2.0 | NaN |
| 1300 | 17374 | Used | 45500.0 | 73.0 | 73.0 | 1 | 1.0 | 0.0 |
| 1301 | 18158 | Used | 46600.0 | 78.0 | 78.0 | 2 | 1.0 | 0.0 |
| 1302 | 19367 | New | 39600.0 | 66.0 | 66.0 | 1 | 1.0 | 0.0 |
| 1303 | 19368 | Used | 63000.0 | 103.0 | 103.0 | 2 | 1.0 | 0.0 |